Subform shows only one record when plenty of room due to 'Default View'.
Cause:
The 'Default View' property is set to 'Single Form' instead of 'Continuous Forms' in the Forms Design view.
Solution:
In the Forms Design view, use the 'Default View' property box in the property sheet to 'Continuous Forms'.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired subform from the list. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Click on the 'Default Views' box. (A down arrow appears.)
7) Click down arrow. (A drop-down list appears.)
8) Select 'Continuous Forms' from the drop-down list.
9) Select the 'File' menu and select 'Save' to save changes to the subform.
